Get Row Item
AutomatR.DefaultActivities.Datatable.GetRowItem
The "Get Row Item" activity in AutomatR allows you to retrieve a value from a row in a DataTable by specifying a particular column. This is useful for extracting specific data points from DataTables during workflow execution.
Properties
| Name | Description |
|---|---|
| Input | |
| Column Index | Specifies the index of the column from which to retrieve the value. If using Column Name, this property can be left empty. Integer variable or argument. |
| Column Name | Specifies the name of the column from which to retrieve the value. If using Column Index, this property can be left empty. String variable or argument. |
| Data Row | Specifies the DataRow from which to retrieve the value. Variable or argument containing the DataRow to read from. |
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variable or argument containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Get Row Item" activity. This can be useful for handling synchronization issues. Integer variable or argument containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Outputs the value of the specified column from the DataRow. String variable or argument to store the retrieved value. |
How to use:
- Drag and drop the "Get Row Item" activity onto the workflow.
- Configure the properties by specifying the DataRow, either the Column Index or Column Name, and optionally customize the display name.
- Execute the workflow to retrieve the specified value from the DataRow.
Example: Consider an example where the "Get Row Item" activity is used to extract the value from the "ColumnName" column of a DataRow:
Get Row Item:
Display Name: "Retrieve Value"
Data Row: dataRowVariable
Column Name: "ColumnName"
Result: extractedValue
In this example, the activity retrieves the value from the "ColumnName" column of the specified DataRow, and the result is stored in the string variable "extractedValue" for further use in the workflow.